Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RECYCLEBIN

Property | Description
--- | ---
Parameter type | Boolean
Syntax | `RECYCLEBIN = [ ON | OFF ]`
Default value | `ON`
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`
Basic | No

`RECYCLEBIN` is used to control whether the Flashback Drop capability is turned on or off. If the parameter is set to `OFF`, then dropped tables do not go into the recycle bin. If this parameter is set to `ON`, dropped tables go into the recycle bin and can be recovered.